select 
Fk.name, 
Fk.object_id, 
Fk.parent_object_id,
OBJECT_NAME(Fk.parent_object_id) as parent_object_name,
CONVERT(bit, case when Fk.is_disabled = 0 then 1 else 0 end) as is_enabled, 
Fk.is_system_named,
Fk.is_not_for_replication, 
Fk.delete_referential_action, 
Fk.update_referential_action, 
CONVERT(bit, case when Fk.is_not_trusted = 0 then 1 else 0 end) as is_checked,
Fk.is_ms_shipped
from sys.foreign_keys Fk 
order by Fk.object_id